Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	40000
Missing cells	26123
Missing cells (%)	3.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.2 MiB
Average record size in memory	136.0 B

Variable types

Numeric	11
Text	2
Categorical	4

Alerts

`obtained_date` is highly imbalanced (74.6%)	Imbalance
`track_name` has 10676 (26.7%) missing values	Missing
`popularity` has 3937 (9.8%) missing values	Missing
`danceability` has 2046 (5.1%) missing values	Missing
`key` has 1376 (3.4%) missing values	Missing
`mode` has 1826 (4.6%) missing values	Missing
`obtained_date` has 6262 (15.7%) missing values	Missing
`instance_id` is uniformly distributed	Uniform
`instance_id` has unique values	Unique
`popularity` has 507 (1.3%) zeros	Zeros
`instrumentalness` has 12011 (30.0%) zeros	Zeros

Reproduction

Analysis started	2024-03-22 17:18:19.852499
Analysis finished	2024-03-22 17:18:39.984911
Duration	20.13 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

instance_id
Real number (ℝ)

UNIFORM UNIQUE

Distinct	40000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26050.117

Minimum	1000
Maximum	50999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	1000
5-th percentile	3514.95
Q1	13554.75
median	26079.5
Q3	38562.25
95-th percentile	48493.05
Maximum	50999
Range	49999
Interquartile range (IQR)	25007.5

Descriptive statistics

Standard deviation	14441.501
Coefficient of variation (CV)	0.55437373
Kurtosis	-1.2006713
Mean	26050.117
Median Absolute Deviation (MAD)	12503
Skewness	-0.004805661
Sum	1.0420047 × 10⁹
Variance	2.0855694 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28097	1	< 0.1%
3473	1	< 0.1%
5453	1	< 0.1%
18742	1	< 0.1%
7314	1	< 0.1%
23964	1	< 0.1%
33538	1	< 0.1%
44474	1	< 0.1%
36120	1	< 0.1%
5052	1	< 0.1%
Other values (39990)	39990	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	1	< 0.1%
1001	1	< 0.1%
1002	1	< 0.1%
1003	1	< 0.1%
1004	1	< 0.1%
1005	1	< 0.1%
1006	1	< 0.1%
1007	1	< 0.1%
1008	1	< 0.1%
1009	1	< 0.1%

Value	Count	Frequency (%)
50999	1	< 0.1%
50998	1	< 0.1%
50997	1	< 0.1%
50996	1	< 0.1%
50995	1	< 0.1%
50994	1	< 0.1%
50993	1	< 0.1%
50992	1	< 0.1%
50991	1	< 0.1%
50990	1	< 0.1%

track_name
Text

MISSING

Distinct	25972
Distinct (%)	88.6%
Missing	10676
Missing (%)	26.7%
Memory size	312.6 KiB

Length

Max length	242
Median length	150
Mean length	20.234757
Min length	1

Characters and Unicode

Total characters	593364
Distinct characters	965
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23450 ?
Unique (%)	80.0%

Sample

1st row	Uber Everywhere
2nd row	Love Is All
3rd row	Should Have Known Better
4th row	Cryin'
5th row	Under The Water

Value	Count	Frequency (%)
	4174	3.8%
the	3222	2.9%
in	1941	1.7%
feat	1622	1.5%
i	1424	1.3%
you	1346	1.2%
no	1263	1.1%
a	1146	1.0%
of	1130	1.0%
me	1013	0.9%
Other values (18411)	92965	83.6%

Most occurring characters

Value	Count	Frequency (%)
	81922	13.8%
e	50333	8.5%
o	35463	6.0%
a	32900	5.5%
n	29339	4.9%
i	29161	4.9%
t	26111	4.4%
r	25186	4.2%
s	17893	3.0%
l	17816	3.0%
Other values (955)	247240	41.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	593364	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	81922	13.8%
e	50333	8.5%
o	35463	6.0%
a	32900	5.5%
n	29339	4.9%
i	29161	4.9%
t	26111	4.4%
r	25186	4.2%
s	17893	3.0%
l	17816	3.0%
Other values (955)	247240	41.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	593364	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	81922	13.8%
e	50333	8.5%
o	35463	6.0%
a	32900	5.5%
n	29339	4.9%
i	29161	4.9%
t	26111	4.4%
r	25186	4.2%
s	17893	3.0%
l	17816	3.0%
Other values (955)	247240	41.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	593364	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	81922	13.8%
e	50333	8.5%
o	35463	6.0%
a	32900	5.5%
n	29339	4.9%
i	29161	4.9%
t	26111	4.4%
r	25186	4.2%
s	17893	3.0%
l	17816	3.0%
Other values (955)	247240	41.7%

popularity
Real number (ℝ)

MISSING ZEROS

Distinct	98
Distinct (%)	0.3%
Missing	3937
Missing (%)	9.8%
Infinite	0
Infinite (%)	0.0%
Mean	44.127638

Minimum	0
Maximum	99
Zeros	507
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0
5-th percentile	18
Q1	34
median	45
Q3	55
95-th percentile	68
Maximum	99
Range	99
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	15.560746
Coefficient of variation (CV)	0.35263038
Kurtosis	0.018666012
Mean	44.127638
Median Absolute Deviation (MAD)	11
Skewness	-0.30713919
Sum	1591375
Variance	242.13681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52	942	2.4%
54	925	2.3%
50	922	2.3%
55	920	2.3%
53	897	2.2%
51	893	2.2%
38	879	2.2%
36	872	2.2%
56	871	2.2%
37	857	2.1%
Other values (88)	27085	67.7%
(Missing)	3937	9.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	507	1.3%
1	26	0.1%
2	41	0.1%
3	32	0.1%
4	31	0.1%
5	19	< 0.1%
6	11	< 0.1%
7	15	< 0.1%
8	39	0.1%
9	39	0.1%

Value	Count	Frequency (%)
99	1	< 0.1%
97	1	< 0.1%
96	1	< 0.1%
95	2	< 0.1%
93	2	< 0.1%
92	1	< 0.1%
91	1	< 0.1%
90	5	< 0.1%
89	6	< 0.1%
88	4	< 0.1%

acousticness
Real number (ℝ)

Distinct	4063
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.30576827

Minimum	0
Maximum	0.996
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.00039
Q1	0.02
median	0.143
Q3	0.551
95-th percentile	0.978
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.531

Descriptive statistics

Standard deviation	0.3414694
Coefficient of variation (CV)	1.1167587
Kurtosis	-0.71805981
Mean	0.30576827
Median Absolute Deviation (MAD)	0.14012
Skewness	0.88629725
Sum	12230.731
Variance	0.11660135
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.995	218	0.5%
0.994	192	0.5%
0.993	164	0.4%
0.992	161	0.4%
0.99	125	0.3%
0.991	120	0.3%
0.989	103	0.3%
0.985	95	0.2%
0.982	92	0.2%
0.987	91	0.2%
Other values (4053)	38639	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1.02 × 10^-6	1	< 0.1%
1.27 × 10^-6	1	< 0.1%
1.37 × 10^-6	1	< 0.1%
1.38 × 10^-6	1	< 0.1%
1.39 × 10^-6	3	< 0.1%
1.46 × 10^-6	1	< 0.1%
1.55 × 10^-6	1	< 0.1%
1.6 × 10^-6	1	< 0.1%
1.62 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.996	70	0.2%
0.995	218	0.5%
0.994	192	0.5%
0.993	164	0.4%
0.992	161	0.4%
0.991	120	0.3%
0.99	125	0.3%
0.989	103	0.3%
0.988	87	0.2%
0.987	91	0.2%

danceability
Real number (ℝ)

MISSING

Distinct	1046
Distinct (%)	2.8%
Missing	2046
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.55823759

Minimum	0.0596
Maximum	0.986
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.0596
5-th percentile	0.235
Q1	0.442
median	0.568
Q3	0.687
95-th percentile	0.838
Maximum	0.986
Range	0.9264
Interquartile range (IQR)	0.245

Descriptive statistics

Standard deviation	0.1783688
Coefficient of variation (CV)	0.3195213
Kurtosis	-0.30556288
Mean	0.55823759
Median Absolute Deviation (MAD)	0.122
Skewness	-0.29036758
Sum	21187.349
Variance	0.031815428
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.529	114	0.3%
0.589	104	0.3%
0.61	103	0.3%
0.499	101	0.3%
0.539	100	0.2%
0.554	100	0.2%
0.657	100	0.2%
0.576	100	0.2%
0.628	99	0.2%
0.54	98	0.2%
Other values (1036)	36935	92.3%
(Missing)	2046	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0596	1	< 0.1%
0.06	1	< 0.1%
0.0606	1	< 0.1%
0.0607	2	< 0.1%
0.061	1	< 0.1%
0.0613	1	< 0.1%
0.0614	1	< 0.1%
0.0616	1	< 0.1%
0.0617	1	< 0.1%
0.0618	1	< 0.1%

Value	Count	Frequency (%)
0.986	1	< 0.1%
0.98	2	< 0.1%
0.979	1	< 0.1%
0.977	1	< 0.1%
0.975	1	< 0.1%
0.973	1	< 0.1%
0.972	1	< 0.1%
0.971	3	< 0.1%
0.969	1	< 0.1%
0.968	1	< 0.1%

duration_ms
Real number (ℝ)

Distinct	22457
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	221080.78

Minimum	-1
Maximum	4830606
Zeros	0
Zeros (%)	0.0%
Negative	3953
Negative (%)	9.9%
Memory size	312.6 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	174793.75
median	219142
Q3	268480
95-th percentile	401000
Maximum	4830606
Range	4830607
Interquartile range (IQR)	93686.25

Descriptive statistics

Standard deviation	129611.78
Coefficient of variation (CV)	0.58626437
Kurtosis	115.46389
Mean	221080.78
Median Absolute Deviation (MAD)	46765
Skewness	4.7786172
Sum	8.843231 × 10⁹
Variance	1.6799214 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	3953	9.9%
192000	25	0.1%
180000	25	0.1%
240000	24	0.1%
208000	17	< 0.1%
216000	15	< 0.1%
200000	15	< 0.1%
210000	15	< 0.1%
182400	14	< 0.1%
270000	13	< 0.1%
Other values (22447)	35884	89.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	3953	9.9%
15509	1	< 0.1%
16316	1	< 0.1%
19693	1	< 0.1%
20096	1	< 0.1%
22750	1	< 0.1%
26293	1	< 0.1%
28947	1	< 0.1%
30027	1	< 0.1%
30097	1	< 0.1%

Value	Count	Frequency (%)
4830606	1	< 0.1%
4497994	1	< 0.1%
4276000	1	< 0.1%
3195440	1	< 0.1%
2764934	1	< 0.1%
2019293	1	< 0.1%
1935787	1	< 0.1%
1872653	1	< 0.1%
1778440	1	< 0.1%
1617333	1	< 0.1%

energy
Real number (ℝ)

Distinct	1990
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.60028519

Minimum	0.000792
Maximum	0.999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.000792
5-th percentile	0.073495
Q1	0.432
median	0.644
Q3	0.817
95-th percentile	0.953
Maximum	0.999
Range	0.998208
Interquartile range (IQR)	0.385

Descriptive statistics

Standard deviation	0.26454414
Coefficient of variation (CV)	0.44069743
Kurtosis	-0.59484455
Mean	0.60028519
Median Absolute Deviation (MAD)	0.188
Skewness	-0.5716041
Sum	24011.407
Variance	0.0699836
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.859	84	0.2%
0.675	81	0.2%
0.805	79	0.2%
0.72	79	0.2%
0.833	77	0.2%
0.978	76	0.2%
0.714	76	0.2%
0.545	75	0.2%
0.83	75	0.2%
0.625	74	0.2%
Other values (1980)	39224	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.000792	1	< 0.1%
0.000795	1	< 0.1%
0.000825	1	< 0.1%
0.0009	1	< 0.1%
0.00101	1	< 0.1%
0.00104	1	< 0.1%
0.00106	2	< 0.1%
0.00108	1	< 0.1%
0.00117	1	< 0.1%
0.00123	1	< 0.1%

Value	Count	Frequency (%)
0.999	4	< 0.1%
0.998	14	< 0.1%
0.997	14	< 0.1%
0.996	25	0.1%
0.995	29	0.1%
0.994	27	0.1%
0.993	25	0.1%
0.992	33	0.1%
0.991	36	0.1%
0.99	35	0.1%

instrumentalness
Real number (ℝ)

ZEROS

Distinct	4970
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.18179051

Minimum	0
Maximum	0.994
Zeros	12011
Zeros (%)	30.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.00015
Q3	0.155
95-th percentile	0.908
Maximum	0.994
Range	0.994
Interquartile range (IQR)	0.155

Descriptive statistics

Standard deviation	0.32541658
Coefficient of variation (CV)	1.7900637
Kurtosis	0.44817693
Mean	0.18179051
Median Absolute Deviation (MAD)	0.00015
Skewness	1.4839272
Sum	7271.6203
Variance	0.10589595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12011	30.0%
0.891	55	0.1%
0.897	54	0.1%
0.898	54	0.1%
0.914	53	0.1%
0.902	52	0.1%
0.912	52	0.1%
0.917	49	0.1%
0.908	49	0.1%
0.934	48	0.1%
Other values (4960)	27523	68.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12011	30.0%
1 × 10^-6	3	< 0.1%
1.01 × 10^-6	23	0.1%
1.02 × 10^-6	15	< 0.1%
1.03 × 10^-6	13	< 0.1%
1.04 × 10^-6	15	< 0.1%
1.05 × 10^-6	17	< 0.1%
1.06 × 10^-6	12	< 0.1%
1.07 × 10^-6	14	< 0.1%
1.08 × 10^-6	14	< 0.1%

Value	Count	Frequency (%)
0.994	1	< 0.1%
0.993	2	< 0.1%
0.992	1	< 0.1%
0.989	1	< 0.1%
0.988	3	< 0.1%
0.987	2	< 0.1%
0.986	3	< 0.1%
0.985	5	< 0.1%
0.984	5	< 0.1%
0.983	4	< 0.1%

key
Categorical

MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	1376
Missing (%)	3.4%
Memory size	312.6 KiB

G	4454
C	4253
C#	4178
D	4123
A	3739
Other values (7)	17877

Length

Max length	2
Median length	1
Mean length	1.3365783
Min length	1

Characters and Unicode

Total characters	51624
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F#
2nd row	C#
3rd row	D
4th row	E
5th row	G

Common Values

Value	Count	Frequency (%)
G	4454	11.1%
C	4253	10.6%
C#	4178	10.4%
D	4123	10.3%
A	3739	9.3%
F	3283	8.2%
B	2889	7.2%
E	2883	7.2%
A#	2641	6.6%
G#	2536	6.3%
Other values (2)	3645	9.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c	8431	21.8%
g	6990	18.1%
a	6380	16.5%
f	5711	14.8%
d	5340	13.8%
b	2889	7.5%
e	2883	7.5%

Most occurring characters

Value	Count	Frequency (%)
#	13000	25.2%
C	8431	16.3%
G	6990	13.5%
A	6380	12.4%
F	5711	11.1%
D	5340	10.3%
B	2889	5.6%
E	2883	5.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	51624	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
#	13000	25.2%
C	8431	16.3%
G	6990	13.5%
A	6380	12.4%
F	5711	11.1%
D	5340	10.3%
B	2889	5.6%
E	2883	5.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	51624	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
#	13000	25.2%
C	8431	16.3%
G	6990	13.5%
A	6380	12.4%
F	5711	11.1%
D	5340	10.3%
B	2889	5.6%
E	2883	5.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	51624	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
#	13000	25.2%
C	8431	16.3%
G	6990	13.5%
A	6380	12.4%
F	5711	11.1%
D	5340	10.3%
B	2889	5.6%
E	2883	5.6%

liveness
Real number (ℝ)

Distinct	1627
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.19380937

Minimum	0.00967
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.00967
5-th percentile	0.0625
Q1	0.0969
median	0.127
Q3	0.24325
95-th percentile	0.548
Maximum	1
Range	0.99033
Interquartile range (IQR)	0.14635

Descriptive statistics

Standard deviation	0.16088587
Coefficient of variation (CV)	0.83012429
Kurtosis	5.6454779
Mean	0.19380937
Median Absolute Deviation (MAD)	0.0446
Skewness	2.236441
Sum	7752.375
Variance	0.025884263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.11	501	1.3%
0.111	487	1.2%
0.108	477	1.2%
0.109	442	1.1%
0.107	422	1.1%
0.112	421	1.1%
0.105	401	1.0%
0.104	399	1.0%
0.106	389	1.0%
0.103	382	1.0%
Other values (1617)	35679	89.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.00967	1	< 0.1%
0.0169	1	< 0.1%
0.0173	1	< 0.1%
0.0188	1	< 0.1%
0.0191	1	< 0.1%
0.0194	1	< 0.1%
0.0204	1	< 0.1%
0.0208	1	< 0.1%
0.0209	1	< 0.1%
0.0212	2	< 0.1%

Value	Count	Frequency (%)
1	2	< 0.1%
0.996	1	< 0.1%
0.993	1	< 0.1%
0.992	1	< 0.1%
0.991	1	< 0.1%
0.99	1	< 0.1%
0.989	1	< 0.1%
0.988	2	< 0.1%
0.987	2	< 0.1%
0.986	2	< 0.1%

loudness
Real number (ℝ)

Distinct	16803
Distinct (%)	42.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-11.667314

Minimum	-108.358
Maximum	1.949
Zeros	0
Zeros (%)	0.0%
Negative	39961
Negative (%)	99.9%
Memory size	312.6 KiB

Quantile statistics

Minimum	-108.358
5-th percentile	-29.80105
Q1	-11.525
median	-7.456
Q3	-5.246
95-th percentile	-3.0979
Maximum	1.949
Range	110.307
Interquartile range (IQR)	6.279

Descriptive statistics

Standard deviation	14.509358
Coefficient of variation (CV)	-1.2435903
Kurtosis	15.401729
Mean	-11.667314
Median Absolute Deviation (MAD)	2.713
Skewness	-3.8320738
Sum	-466692.56
Variance	210.52148
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-5.133	15	< 0.1%
-3.665	14	< 0.1%
-5.606	14	< 0.1%
-7.066	13	< 0.1%
-4.566	13	< 0.1%
-5.982	13	< 0.1%
-5.443	13	< 0.1%
-5.659	13	< 0.1%
-6.217	13	< 0.1%
-7.321	12	< 0.1%
Other values (16793)	39867	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-108.358	1	< 0.1%
-107.986	1	< 0.1%
-106.758	1	< 0.1%
-106.111	1	< 0.1%
-105.191	1	< 0.1%
-105.112	1	< 0.1%
-105.09	1	< 0.1%
-104.741	1	< 0.1%
-104.34	1	< 0.1%
-104.267	1	< 0.1%

Value	Count	Frequency (%)
1.949	1	< 0.1%
1.61	1	< 0.1%
1.585	1	< 0.1%
1.342	1	< 0.1%
1.314	1	< 0.1%
1.275	1	< 0.1%
1.012	1	< 0.1%
0.954	1	< 0.1%
0.899	1	< 0.1%
0.892	1	< 0.1%

mode
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1826
Missing (%)	4.6%
Memory size	312.6 KiB

Major	24553
Minor	13621

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	190870
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Minor
2nd row	Major
3rd row	Minor
4th row	Minor
5th row	Major

Common Values

Value	Count	Frequency (%)
Major	24553	61.4%
Minor	13621	34.1%
(Missing)	1826	4.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
major	24553	64.3%
minor	13621	35.7%

Most occurring characters

Value	Count	Frequency (%)
M	38174	20.0%
o	38174	20.0%
r	38174	20.0%
a	24553	12.9%
j	24553	12.9%
i	13621	7.1%
n	13621	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	190870	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	38174	20.0%
o	38174	20.0%
r	38174	20.0%
a	24553	12.9%
j	24553	12.9%
i	13621	7.1%
n	13621	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	190870	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	38174	20.0%
o	38174	20.0%
r	38174	20.0%
a	24553	12.9%
j	24553	12.9%
i	13621	7.1%
n	13621	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	190870	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	38174	20.0%
o	38174	20.0%
r	38174	20.0%
a	24553	12.9%
j	24553	12.9%
i	13621	7.1%
n	13621	7.1%

speechiness
Real number (ℝ)

Distinct	2019
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1298754

Minimum	0.0223
Maximum	1.889
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0.0223
5-th percentile	0.0282
Q1	0.0364
median	0.0504
Q3	0.114
95-th percentile	0.438
Maximum	1.889
Range	1.8667
Interquartile range (IQR)	0.0776

Descriptive statistics

Standard deviation	0.21232388
Coefficient of variation (CV)	1.6348274
Kurtosis	13.870344
Mean	0.1298754
Median Absolute Deviation (MAD)	0.0187
Skewness	3.6344209
Sum	5195.0162
Variance	0.045081428
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0332	140	0.4%
0.0337	125	0.3%
0.0315	124	0.3%
0.0329	123	0.3%
0.0358	120	0.3%
0.0364	112	0.3%
0.0291	112	0.3%
0.0356	111	0.3%
0.0343	111	0.3%
0.0323	111	0.3%
Other values (2009)	38811	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0223	1	< 0.1%
0.0224	3	< 0.1%
0.0225	1	< 0.1%
0.0226	2	< 0.1%
0.0227	1	< 0.1%
0.0228	6	< 0.1%
0.0229	2	< 0.1%
0.023	1	< 0.1%
0.0231	5	< 0.1%
0.0232	3	< 0.1%

Value	Count	Frequency (%)
1.889	1	< 0.1%
1.739	1	< 0.1%
1.642	1	< 0.1%
1.623	1	< 0.1%
1.622	1	< 0.1%
1.576	1	< 0.1%
1.515	1	< 0.1%
1.504	1	< 0.1%
1.5	1	< 0.1%
1.491	1	< 0.1%

tempo
Text

Distinct	25010
Distinct (%)	62.5%
Missing	0
Missing (%)	0.0%
Memory size	312.6 KiB

Length

Max length	18
Median length	17
Mean length	8.39585
Min length	1

Characters and Unicode

Total characters	335834
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18454 ?
Unique (%)	46.1%

Sample

1st row	167.357
2nd row	140.181
3rd row	?
4th row	120.052
5th row	90.97200000000001

Value	Count	Frequency (%)
	3996	10.0%
100.00299999999999	15	< 0.1%
130.016	14	< 0.1%
140.011	13	< 0.1%
140.007	13	< 0.1%
120.01899999999999	12	< 0.1%
130.04	12	< 0.1%
119.985	12	< 0.1%
100.014	12	< 0.1%
129.984	11	< 0.1%
Other values (25000)	35890	89.7%

Most occurring characters

Value	Count	Frequency (%)
9	72983	21.7%
0	63881	19.0%
1	44363	13.2%
.	36004	10.7%
2	19323	5.8%
7	17907	5.3%
8	17875	5.3%
5	15256	4.5%
4	15189	4.5%
3	15156	4.5%
Other values (2)	17897	5.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	335834	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	72983	21.7%
0	63881	19.0%
1	44363	13.2%
.	36004	10.7%
2	19323	5.8%
7	17907	5.3%
8	17875	5.3%
5	15256	4.5%
4	15189	4.5%
3	15156	4.5%
Other values (2)	17897	5.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	335834	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	72983	21.7%
0	63881	19.0%
1	44363	13.2%
.	36004	10.7%
2	19323	5.8%
7	17907	5.3%
8	17875	5.3%
5	15256	4.5%
4	15189	4.5%
3	15156	4.5%
Other values (2)	17897	5.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	335834	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	72983	21.7%
0	63881	19.0%
1	44363	13.2%
.	36004	10.7%
2	19323	5.8%
7	17907	5.3%
8	17875	5.3%
5	15256	4.5%
4	15189	4.5%
3	15156	4.5%
Other values (2)	17897	5.3%

obtained_date
Categorical

IMBALANCE MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	6262
Missing (%)	15.7%
Memory size	312.6 KiB

4-Apr	30192
3-Apr	2718
5-Apr	553
1-Apr	274
0/4	1

Length

Max length	5
Median length	5
Mean length	4.9999407
Min length	3

Characters and Unicode

Total characters	168688
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	4-Apr
2nd row	4-Apr
3rd row	4-Apr
4th row	4-Apr
5th row	4-Apr

Common Values

Value	Count	Frequency (%)
4-Apr	30192	75.5%
3-Apr	2718	6.8%
5-Apr	553	1.4%
1-Apr	274	0.7%
0/4	1	< 0.1%
(Missing)	6262	15.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4-apr	30192	89.5%
3-apr	2718	8.1%
5-apr	553	1.6%
1-apr	274	0.8%
0/4	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
-	33737	20.0%
A	33737	20.0%
p	33737	20.0%
r	33737	20.0%
4	30193	17.9%
3	2718	1.6%
5	553	0.3%
1	274	0.2%
0	1	< 0.1%
/	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	168688	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	33737	20.0%
A	33737	20.0%
p	33737	20.0%
r	33737	20.0%
4	30193	17.9%
3	2718	1.6%
5	553	0.3%
1	274	0.2%
0	1	< 0.1%
/	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	168688	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	33737	20.0%
A	33737	20.0%
p	33737	20.0%
r	33737	20.0%
4	30193	17.9%
3	2718	1.6%
5	553	0.3%
1	274	0.2%
0	1	< 0.1%
/	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	168688	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	33737	20.0%
A	33737	20.0%
p	33737	20.0%
r	33737	20.0%
4	30193	17.9%
3	2718	1.6%
5	553	0.3%
1	274	0.2%
0	1	< 0.1%
/	1	< 0.1%

valence
Real number (ℝ)

Distinct	1594
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.45709956

Minimum	0
Maximum	0.992
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	312.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0669
Q1	0.257
median	0.4505
Q3	0.649
95-th percentile	0.877
Maximum	0.992
Range	0.992
Interquartile range (IQR)	0.392

Descriptive statistics

Standard deviation	0.24712314
Coefficient of variation (CV)	0.54063307
Kurtosis	-0.9321704
Mean	0.45709956
Median Absolute Deviation (MAD)	0.1955
Skewness	0.12586194
Sum	18283.982
Variance	0.061069846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.338	85	0.2%
0.332	74	0.2%
0.362	72	0.2%
0.347	71	0.2%
0.474	71	0.2%
0.324	69	0.2%
0.351	69	0.2%
0.569	68	0.2%
0.358	68	0.2%
0.354	68	0.2%
Other values (1584)	39285	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
0.0193	1	< 0.1%
0.0241	1	< 0.1%
0.0246	1	< 0.1%
0.0247	1	< 0.1%
0.0251	1	< 0.1%
0.0252	1	< 0.1%
0.0262	1	< 0.1%
0.0264	2	< 0.1%
0.0266	1	< 0.1%

Value	Count	Frequency (%)
0.992	1	< 0.1%
0.99	1	< 0.1%
0.987	1	< 0.1%
0.986	1	< 0.1%
0.985	4	< 0.1%
0.984	1	< 0.1%
0.983	1	< 0.1%
0.982	3	< 0.1%
0.98	3	< 0.1%
0.979	2	< 0.1%

music_genre
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	312.6 KiB

Alternative	4059
Jazz	4055
Electronic	4020
Anime	4017
Blues	3987
Other values (5)	19862

Length

Max length	11
Median length	9
Mean length	6.507075
Min length	3

Characters and Unicode

Total characters	260283
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Country
2nd row	Rap
3rd row	Jazz
4th row	Hip-Hop
5th row	Rock

Common Values

Value	Count	Frequency (%)
Alternative	4059	10.1%
Jazz	4055	10.1%
Electronic	4020	10.1%
Anime	4017	10.0%
Blues	3987	10.0%
Country	3985	10.0%
Rap	3980	10.0%
Classical	3980	10.0%
Rock	3960	9.9%
Hip-Hop	3957	9.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
alternative	4059	10.1%
jazz	4055	10.1%
electronic	4020	10.1%
anime	4017	10.0%
blues	3987	10.0%
country	3985	10.0%
rap	3980	10.0%
classical	3980	10.0%
rock	3960	9.9%
hip-hop	3957	9.9%

Most occurring characters

Value	Count	Frequency (%)
e	20142	7.7%
a	20054	7.7%
i	20033	7.7%
l	20026	7.7%
t	16123	6.2%
n	16081	6.2%
c	15980	6.1%
o	15922	6.1%
r	12064	4.6%
s	11947	4.6%
Other values (15)	91911	35.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	260283	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	20142	7.7%
a	20054	7.7%
i	20033	7.7%
l	20026	7.7%
t	16123	6.2%
n	16081	6.2%
c	15980	6.1%
o	15922	6.1%
r	12064	4.6%
s	11947	4.6%
Other values (15)	91911	35.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	260283	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	20142	7.7%
a	20054	7.7%
i	20033	7.7%
l	20026	7.7%
t	16123	6.2%
n	16081	6.2%
c	15980	6.1%
o	15922	6.1%
r	12064	4.6%
s	11947	4.6%
Other values (15)	91911	35.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	260283	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	20142	7.7%
a	20054	7.7%
i	20033	7.7%
l	20026	7.7%
t	16123	6.2%
n	16081	6.2%
c	15980	6.1%
o	15922	6.1%
r	12064	4.6%
s	11947	4.6%
Other values (15)	91911	35.3%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	instance_id	track_name	popularity	acousticness	danceability	duration_ms	energy	instrumentalness	key	liveness	loudness	mode	speechiness	tempo	obtained_date	valence	music_genre
0	28097	NaN	38.0	0.045500	NaN	152427.0	0.636	0.020200	F#	0.1110	-9.109	Minor	0.0591	167.357	4-Apr	0.597	Country
1	49793	Uber Everywhere	67.0	0.054200	0.779	-1.0	0.455	0.000000	C#	0.1770	-15.025	Major	0.2800	140.181	4-Apr	0.197	Rap
2	41545	Love Is All	37.0	0.583000	0.660	311008.0	0.650	0.056200	D	0.3980	-7.738	Minor	0.0288	?	NaN	0.692	Jazz
3	23453	NaN	69.0	0.012200	0.680	200000.0	0.597	0.000599	E	0.1140	-7.198	Minor	0.0304	120.052	4-Apr	0.300	Hip-Hop
4	33933	Should Have Known Better	64.0	0.979000	0.571	307698.0	0.172	0.275000	G	0.1240	-20.700	Major	0.0318	90.97200000000001	4-Apr	0.297	Rock
5	3872	NaN	68.0	0.002420	0.585	237040.0	0.842	0.006860	A	0.0866	-75.883	NaN	0.0556	118.211	4-Apr	0.428	Rock
6	37110	Cryin'	70.0	0.000202	0.445	308333.0	0.856	0.010100	A	0.3670	-3.674	Major	0.0327	105.87200000000001	3-Apr	0.486	Rock
7	47456	Under The Water	51.0	0.053900	0.611	203915.0	0.644	0.000000	NaN	0.0802	-5.394	Major	0.0750	144.041	4-Apr	0.440	Rock
8	22862	Chanel Junkie (feat. Future)	50.0	0.050800	0.842	193732.0	0.676	0.000000	B	0.0732	-4.368	Minor	0.2240	140.047	4-Apr	0.464	Hip-Hop
9	43030	Blackbird	49.0	0.037700	0.720	567459.0	0.791	0.730000	G	0.5040	-6.902	Minor	0.0361	95.01	4-Apr	0.535	Jazz

	instance_id	track_name	popularity	acousticness	danceability	duration_ms	energy	instrumentalness	key	liveness	loudness	mode	speechiness	tempo	obtained_date	valence	music_genre
39990	11860	Ali Bomaye	66.0	0.0203	0.378	372707.0	0.6910	0.000000	A#	0.4000	-5.308	Minor	0.4610	75.16199999999999	4-Apr	0.226	Rap
39991	46479	Agony	55.0	0.9420	0.578	214173.0	0.1660	0.006900	E	0.1030	-17.194	Major	0.0335	99.891	4-Apr	0.318	Rap
39992	7823	NaN	NaN	0.0304	NaN	243100.0	0.9440	0.000002	F#	0.0948	-1.669	Minor	0.0613	114.887	NaN	0.549	Anime
39993	34030	NaN	46.0	0.0516	0.754	220467.0	0.6840	0.000053	E	0.1070	-10.377	Major	0.0291	116.955	4-Apr	0.775	Country
39994	23298	Take Care of Momma	NaN	0.5660	0.837	316360.0	0.2440	0.000002	G	0.1000	-13.606	Minor	0.0750	105.98100000000001	NaN	0.665	Blues
39995	20742	Violin Concerto in G Minor, RV 315, "Summer" from "The Four Seasons": III. Presto. Tempo impettuoso d'estate	36.0	0.9290	0.306	157994.0	0.3410	0.913000	C	0.1620	-16.957	Minor	0.0359	151.375	3-Apr	0.383	Classical
39996	40095	Hey There	47.0	0.8610	0.649	335320.0	0.0969	0.452000	C	0.0955	-19.541	NaN	0.0434	112.038	4-Apr	0.306	Jazz
39997	21931	NaN	0.0	0.0568	0.475	219880.0	0.9650	0.000000	C#	0.1370	-2.877	Major	0.0462	171.882	4-Apr	0.868	Country
39998	30480	Dna Rhapsody	14.0	0.0317	0.480	255627.0	0.9430	0.000018	A	0.3450	-0.764	Minor	0.2370	174.062	4-Apr	0.705	Anime
39999	18781	Objects in the Mirror	NaN	0.6230	NaN	259144.0	0.6580	0.000019	C#	0.1070	-6.625	Major	0.0532	77.021	4-Apr	0.190	Hip-Hop

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample